-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: mysql5.cws.oregonstate.edu
-- Generation Time: May 22, 2019 at 12:40 PM
-- Server version: 5.1.63
-- PHP Version: 5.3.3-7+squeeze9

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `cw_61046`
--

-- --------------------------------------------------------

--
-- Table structure for table `CodesFishOld`
--

CREATE TABLE IF NOT EXISTS `CodesFishOld` (
  `ManagCode` text NOT NULL,
  `ManagDescrip` text NOT NULL,
  `ManagType` text NOT NULL,
  `ManagNotes` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CodesFishOld`
--

INSERT INTO `CodesFishOld` (`ManagCode`, `ManagDescrip`, `ManagType`, `ManagNotes`) VALUES
('AUR', 'Blue tilapia', 'PROD_FISH', 'Oreochromis aureus'),
('BCP', 'Black carp', 'PROD_FISH', 'Mylopharyngodon piceus'),
('CCP', 'Common carp', 'PROD_FISH', 'Cyprinus carpio'),
('CHA', 'Milkfish', 'PROD_FISH', 'Chanos chanos'),
('CICHL', 'Guapote tigre, mojarra pinta, tiger cichlid', 'PROD_FISH', 'Cichlasoma managuense. Family cichlid. This fish has been used in Central America as a predator for tilapia culture (polyculture). They are very voracious and can eat tilapia juveniles\r\rthat are fairly large, their mouth is protractile allowing them to catch\r\rlarge prey..\r\r\r\rThey are sold in aquaria as pets.'),
('COLOS', 'Cachama (Columbia), tambaqui (Brazil)', 'PROD_FISH', 'Colossoma macropomum'),
('FAC_NIL', 'Nile tilapia (Philippines strain)', 'PROD_FISH', 'Oreochromis niloticus, Freshwater Aquaculture Center (Philippines) strain'),
('FISH_UNKNOWN', 'Unknown fish name', 'PROD_FISH', 'Unknown fish specie'),
('GARIE', 'Clarias, African catfish', 'PROD_FISH', 'Clarias gariepinus'),
('MON', 'Monodon shrimp', 'PROD_FISH', 'Penaeus monodon'),
('MUL', 'Mullet', 'PROD_FISH', 'Mugil curema'),
('MXG', 'Hybrid clarius', 'PROD_FISH', 'Clarias macrocephalus x C. gariepinus'),
('NIL', 'Nile tilapia', 'PROD_FISH', 'Oreochromis niloticus, ivory coast or Egypt strain'),
('NIL1', 'Nile tilapia, additional fish size class 1, when > 1.0 size class is stocked', 'PROD_FISH', 'NIL, additional fish size class 1'),
('NIL2', 'Nile tilapia, additional fish size class 2, when > 2.0 size classes are stocked', 'PROD_FISH', 'NIL, additional fish size class 2'),
('PACO', 'Paco (S. America) or Pacu (?)', 'PROD_FISH', 'Piaractus brachypomus'),
('RED_NIL', 'Red Nile tilapia', 'PROD_FISH', 'Oreochromis niloticus, red hybrid'),
('SGMT_NIL', 'Nile tilapia (genetic male)', 'PROD_FISH', 'Oreochromis niloticus, genetically male tilapia, Swansea stock'),
('STRIA', 'Channa striata, dalag', 'PROD_FISH', 'Channa striata'),
('STY', 'Stylirostis shrimp', 'PROD_FISH', 'Penaeus stylirostis'),
('THAI_NIL', 'Nile tilapia (Thailand strain)', 'PROD_FISH', 'Oreochromis niloticus, Thailand strain'),
('VAN', 'Vannamei shrimp', 'PROD_FISH', 'Penaeus vannamei'),
('ZIL', 'Zilli tilapia', 'PROD_FISH', 'Tilapia zilliei');
